<?php 
	error_reporting(E_WARNING);
	include_once '../metodos.php';
	include_once '../conexao.php';
?>
<head>
	<link rel="stylesheet" href="jquery-ui-1.8.16.custom/development-bundle/themes/base/jquery.ui.all.css">
	<script src="jquery-ui-1.8.16.custom/development-bundle/jquery-1.6.2.js"></script>
	<script src="jquery-ui-1.8.16.custom/development-bundle/ui/jquery.ui.core.js"></script>
	<script src="jquery-ui-1.8.16.custom/development-bundle/ui/jquery.ui.widget.js"></script>
	<script src="jquery-ui-1.8.16.custom/development-bundle/ui/jquery.ui.datepicker.js"></script>
	<script src="jquery-ui-1.8.16.custom/development-bundle/external/jquery.bgiframe-2.1.2.js"></script>
	<script src="jquery-ui-1.8.16.custom/development-bundle/ui/jquery.ui.mouse.js"></script>
	<script src="jquery-ui-1.8.16.custom/development-bundle/ui/jquery.ui.draggable.js"></script>
	<script src="jquery-ui-1.8.16.custom/development-bundle/ui/jquery.ui.position.js"></script>
	<script src="jquery-ui-1.8.16.custom/development-bundle/ui/jquery.ui.resizable.js"></script>
	<script src="jquery-ui-1.8.16.custom/development-bundle/ui/jquery.ui.dialog.js"></script>
	<script src="jquery-ui-1.8.16.custom/development-bundle/ui/jquery.ui.button.js"></script>
	<script src="jquery-ui-1.8.16.custom/development-bundle/ui/jquery.effects.core.js"></script>
	<script src="jquery-ui-1.8.16.custom/development-bundle/ui/jquery.ui.autocomplete.js"></script>
	<link rel="stylesheet" href="jquery-ui-1.8.16.custom/development-bundle/demos/demos.css">

	<style>
		body { font-size: 62.5%; }
		label, input { display:block; }
		input.text { margin-bottom:12px; width:95%; padding: .4em; }
		fieldset { padding:0; border:0; margin-top:25px; }
		h1 { font-size: 1.2em; margin: .6em 0; }
		div#users-contain { width: 350px; margin: 20px 0; }
		div#users-contain table { margin: 1em 0; border-collapse: collapse; width: 100%; }
		div#users-contain table td, div#users-contain table th { border: 1px solid #eee; padding: .6em 10px; text-align: left; }
		.ui-dialog .ui-state-error { padding: .3em; }
		.validateTips { border: 1px solid transparent; padding: 0.3em; }
	</style>

	<script>
	$(function() {
		$( "#datepicker" ).datepicker();
	});
	</script>
</head>

<script language="Javascript">
	function popup(){
		window.open('http://localhost/SGP/lixo/popup.php','janela','toolbar=no,location=no, directories=no,status=no,menubar=no,scrollbars=yes,resizable=yes,menubar=no,width=315,height=80' );
	}
</script>


<form action="agenda.php" method="post">
<span>Agenda de </span>
<SELECT name="podo">
	<?php 
	$sql = mysql_query("SELECT * FROM tb_funcionario");
	while ($row = mysql_fetch_array($sql)){
		echo '<OPTION value="'.$row['id'].'">'.$row['nome'].' '.$row['sobrenome'].'</OPTION>';
	}
	?>
</SELECT>
<input type="hidden" name="cmd" value="agenda">
Data: <input type="text" id="datepicker" name="data">
<input type="submit" value="Buscar">
</form>
<hr>
	
	<?php 
	if(isset($_POST['cmd']) || $_POST['cmd']=='agenda'){
		$query = mysql_query("SELECT * FROM tb_cliente");
		//autocomplite de clientes
		?>
		<script>
	$(function() {
		var availableTags = [
			<?php 
				while ($row_cliente = mysql_fetch_array($query)){
					echo '"'.utf8_encode($row_cliente['nome']).' '.utf8_encode($row_cliente['sobrenome']).'",';
				}
			?>
		];
		$( "#tags" ).autocomplete({
			source: availableTags
		});
	});
	</script>
		
<?php
		
		$c = 1;
		$hora = array(1=>'08:00',2=>'08:40', 3=>'09:20',4=>'10:00',5=>'10:40', 6=>'11:20',7=>'12:00', 8=>'12:40', 9=>'13:20', 10=>'14:00', 11=>'14:40'
						, 12=>'15:20', 13=>'16:00', 14=>'16:40', 15=>'17:20', 16=>'18:00');

		if(empty($_POST['data'])){
			$data=date("Y-m-d");
		}else{
			$data = $_POST['data'];
		}
		//Criando os horarios
		echo '<table>';
		while ($c<17){
			echo '<tr><td width="50px"><strong>'.$hora[$c].'</strong></td>';
			$agenda = mysql_query("SELECT * FROM tb_agenda a, tb_cliente c WHERE a.hora='".$hora[$c].":00' AND a.data='".$data."' AND a.id_cliente=c.id AND a.id_funcionario=".$_POST['podo']. " ORDER BY a.hora LIMIT 1");
			$num = mysql_num_rows($agenda);
			if($num>0){
			$row = mysql_fetch_array($agenda);
			echo '<td>'.utf8_encode($row['nome']).' '.utf8_encode($row['sobrenome']).'</td></tr>';
			}else{
				echo '<td><form action="new.php" method="post">
						<input type="hidden" name="hora" value=""/>
						<input type="submit" value="Marcar">
					</form></td>';
			}
			++$c;
		}
		echo '</table>';
	}
?>